package com.ruoyi.system.mapper;

import java.math.BigDecimal;
import java.util.List;
import com.ruoyi.system.domain.SysHousing;
import org.apache.ibatis.annotations.Param;
import org.springframework.security.core.parameters.P;

/**
 * 小区Mapper接口
 * 
 * @author ruoyi
 * @date 2024-08-07
 */
public interface SysHousingMapper 
{
    /**
     * 查询小区
     * 
     * @param housingId 小区主键
     * @return 小区
     */
    public SysHousing selectSysHousingByHousingId(Long housingId);

    /**
     * 查询小区列表
     * 
     * @param sysHousing 小区
     * @return 小区集合
     */
    public List<SysHousing> selectSysHousingList(SysHousing sysHousing);


    /**
     * 查询总储水量
     * @param deptId
     * @return
     */
    public BigDecimal totalTankVolume (Long deptId);
    /**
     * 新增小区
     * 
     * @param sysHousing 小区
     * @return 结果
     */
    public int insertSysHousing(SysHousing sysHousing);

    /**
     * 修改小区
     * 
     * @param sysHousing 小区
     * @return 结果
     */
    public int updateSysHousing(SysHousing sysHousing);

    /**
     * 删除小区
     * 
     * @param housingId 小区主键
     * @return 结果
     */
    public int deleteSysHousingByHousingId(Long housingId);

    /**
     * 批量删除小区
     * 
     * @param housingIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSysHousingByHousingIds(Long[] housingIds);

    /**
     * 绑定热费
     * @param housingId
     * @param heatFeeId
     */
    public void bindHeatFeedId(@Param("heatFeeId") Long heatFeeId, @Param("housingId") Long housingId);

    /**
     * 解绑热费
     * @param heatFeeId
     */
    public void restHeatFeedId(@Param("heatFeeId") Long heatFeeId);
}
